<?php
/**
 * Prado Portal.
 *
 * @author Steen Rabol <steen.rabol@gmail.com>
 * @link http://www.pradoportal.dk/
 * @copyright Copyright &copy; 2006,2007,2008 Steen Rabol
 * @license http://www.pradoportal.dk
 * @version $Id: MySQL.php 289 2008-11-14 05:34:40Z steen.rabol@gmail.com $
 * @package Pradoportal.Portlets.NewsPortlet.Install.MySQL
 *
 */
$drop_table[] = "DROP TABLE IF EXISTS tblnews";
$create_table[] = "CREATE TABLE tblnews (
  id int(10) unsigned NOT NULL auto_increment,
  contentid int(10) unsigned NOT NULL default '0',
  subject varchar(45) NOT NULL default '',
  body text NOT NULL,
  expire int(10) unsigned NOT NULL default '0',
  created int(10) unsigned NOT NULL default '0',
  createdby int(10) unsigned NOT NULL default '0',
  modified int(10) unsigned NOT NULL default '0',
  modifiedby int(10) unsigned NOT NULL default '0',
  isglobal int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
)";

?>